Creating Custom Lists

Design your own list that can be directly associated with a form field. Define the rows, columns, and data types that you want to appear in the list. If you're planning to re-use this list, save it as a template, so you can re-use it in other returns.

Custom lists will roll over with any returns you roll from the last month or last quarter.

The two-part Custom List dialog box allows you to simultaneously:

  1. Design the list;
  2. View and edit the list.

You can also choose to save the list as a template to be used on other lines or in other returns.

Custom List Dialog

To open the Custom List dialog box:

  1. In an open return, open the form to which you want to add the list.
  2. Move the cursor to the field where you want to add the list.
  3. Do one of the following:
  4. Click the Forms menu; then, select Lists; then, select Custom List.
  5. Right-click; then, select Custom List.

Custom List dialog box

About the dialog box

The Custom List dialog box is made up of two window panes:

Design Your List pane

If you're creating a brand new list from "scratch," the Design Your List pane (top) helps you 1) create the columns you want in your list; 2) determine the format of the data in each column (such as Text, Date, Number, or Percent); and 3) indicate whether or not you want a column's total to link to the form.

View & Edit Your List pane

The bottom pane allows you to view and/or edit the list that you designed in the Design Your List pane. You can also import data from another list (saved in .csv format) and/or export data to a .csv file.

Designing a List from Scratch

To design a completely new Custom List from scratch:

  1. Follow directions above to open the Custom List dialog box. The Custom List dialog box opens. The Create from scratch radio button is already selected.
  2. Tab to the first row under the Column Name. Enter the first column's name (by typing over the default text).
  3. Tab to the Column Formatting field; when the drop-down arrow appears, click the arrow. The list of available formats appears:

List of available column formats

  1. Select the type of data format for the information in that column.
  2. To set up another column, click the Add Column button.
  3. Repeat steps 2 through 5 for every column.
  4. (OPTIONAL) If you'd like the total from one column to be linked to the form, click the Link Column Total To Form check box for that column.

Only one column in each list can be linked to the form.

  1. In the List Name field (in the View & Edit Your List pane), enter a name for your list.

When you're finished setting up your columns, the list should appear in the View & Edit Your List pane:

Custom List dialog box, with View & Edit Your List pane

  1. Click OK to save the new custom list in that field on the form.

The dialog box closes. The list is saved on the field where you entered it. The field background color is turned green, indicating the presence of a list.

Opening a Custom List

To open a custom list:

  1. In an open return, place your cursor in a field that has a custom list (fields with lists have green backgrounds).
  2. Do one of the following:
  3. Click the Forms menu; then, select Lists; then, select Custom List.
  4. Right-click; then, select Custom List.

Custom List (with Design Your List collapsed)

Removing a List from a Field

To remove a list that that's been added to a form field:

  1. In the open return, place the cursor in the field with the list you want to remove.
  2. Click the Forms menu.
  3. Select Lists; then, select Remove List.

Remove List dialog box

  1. Click Remove.

Deleting Columns

To delete a list column:

  1. Click the Delete Column button in the Design Your List pane (top).

Delete Column Confirmation message

If you have entered data in the column you're deleting, you will lose the data.

  1. Click Delete Column.

Saving a List as a Template

Once created, any list can be saved as a template for use in any return. Users can roll over their own custom list templates from year to year by selecting the Custom List Templates check box at the bottom of the Rollover Manager. See Rollover Other Data.

To save a list as a template:

  1. From the return, place your cursor on the green field with the list.
  2. Do one of the following:
  3. Click the Forms menu; then, select Lists; then, select Custom List.
  4. Right-click; then, select Custom List.

The Custom List dialog box appears.

  1. Click the Save As Template button.

The Template Name dialog box appears.

  1. Enter the name of the template:

Template Name dialog box

  1. Click Save.

The List Source has now been changed, and the template appears in the drop-down:

Design Your List pane, template selection highlighted

This template will now be available whenever you open the Custom List feature.

Updating a Template

To update a template:

  1. Open the Custom List dialog box.

See Opening a Custom List.

  1. Click the down arrow beside the Design Your List pane.
  2. Select the Use a Template radio button.
  3. From the drop-down list, select the template you want to update:

Update List Source Confirmation

  1. Click Update List Source.

The Custom List dialog box opens.

  1. In the Design Your List pane, make changes to the columns, data format, or link to form selection.
  2. Click the Save Template button.
  3. Click OK.

Managing List Templates

The Manage Templates function allows you to delete or rename a template.

To delete a custom list template:

  1. From the Custom List dialog box, click the Manage Templates button.

Manage Templates dialog box

  1. Select the Delete check box for the template.
  2. Click Save.

To rename a custom list template:

  1. From the Custom List dialog box, click the Manage Templates button.

The Manage Templates dialog box appears.

  1. Double-click the template name.
  2. Type the new name in the field (overwriting the old name).
  3. Click Save.

Importing Data into a List

You can import data from any file saved in .csv format into a new or existing custom list. See Saving an .xls as .csv.

However, before you import, please note: the number of columns in the import data must match the number of columns in the custom list. If you have the same number of columns, proceed with your import; if you don't, it makes this a two-part process. First, you must set up or adjust the number of columns in the custom list to match the number of columns in the imported data. When this is done, you can then import the data.

Part 1: Setting Up Columns to Receive the Imported Data

Before you begin, you must know how many data columns you'll need in the list to accommodate the imported data.

  1. Open the Custom List dialog box.
  1. In the Design Your List pane, click the Add Column button until the number of columns you've added matches the number of columns in the import file.

Part 2: Importing the Data

  1. From the Custom List dialog box, in the Design Your List pane, click the Import button.
  2. Select the .csv file to import.

See Importing Data from .csv Files.

Exporting Data from the List

You can export data from a custom list to a .csv file.

To export data from your list, see Exporting Lists.

 

See Also:

Lists Overview

Creating Itemized Lists

Creating Text Lists

Importing Existing Files into Lists

Exporting Lists

Printing Lists

Removing Lists

Deleting Rows from Lists